SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=3 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+software +jobs' IN BOOLEAN MODE)) AND iCityID IN (2848,2872,3068,2969,2834,3054,16253,2808,16129,3035,3040,2866,16507,16196,2956,2806,2912,2941,3058,3075,2929,2934,2963,2821,2889,2936,2937,2832,2786,3052,16220,3081,3082,16506,2835,2828,2887,2858,2991,16505,2871,2794,2793,2971,2853,2919,3016,513,2974,2939,16232,2957,16242,3034,515,3065,3024,3064,516,16460,2877,2831,16504,2824,2967,6303,2892,512,2784,2955,2891,2839,2897,6579,2938,2788,3056,6321,6471,2766,2792,6312,2905,3041,514,6452,2781,7,2911,2874,2823,6473,6578,6316,2878,2875,3045,2796,3078,6496,2822,2870,2804,2785,6588,2927,6485,2837,2844,6434,3049,2774,16213,2764,3048,6459,6424,2928,3076,2980,2851,2865,2852,16240,2830,2890,6652,3067,6520,2802,2884,6307,2958,6601,3071,2942,16191,6560,6545,16252,6474,2800,3028,2978,6540,3015,6408,6522,6572,2943,2773,2827,2989,3050,2782,2986,16626,2798,6644,2883,2845,6624,16194,2950,2873,6484,16228,2840,2981,2856,3026,3032,3033,6512,3036,3039,2881,2960,3004,6629,6350,2993,21,6499,3023,16654,16197,3020,3018,3037,3005,2908,2976,2913,2917,2770,6649,16533,6548,2916,6420,2817,2910,2987,2768,2921,2847,2932,2914,6549,16214,3047,6448,3038,6421,6650,2772,3011,2994,2904,3063,6487,2888,6573,2982,3070,2882,2869,6564,2861,6402,2833,2815,2895,2807,2947,6395,3007,2843,2968,6449,2935,2893,6463,16574,2920,3009,6368,6503,6430,2862,6615,6547,6359,6361,2769,2776,2940,2795,3019,6526,2962,2810,2886,2813,6656,6345,6609,6386,6405,6406,2922,6511,3053,6498,6622,6510,16224,6626,6613,6641,2819,6475,3080,6597,2775,2850,2825,2801,2842,16534,6348,2966,2948,6313,3003,2816,3010,2951,2855,16532,6341,2771,3055,6336,3030,6323,2998,2894,6394,6497,3025,2859,2896,2864,6311,2885,2970,2952,6542,6438,2990,3027,3022,2988,6460,6494,2992,3061,3066,2964,6603,2953,2944,16116,6349,2961,6383,2809,2902,3012,2789,3060,16246,2818,2803,6481,2946,3077,2799,3044,2854,2765,2849,2995,2778,6554,3051,2829,3002,6537,2812,2777,2767,2915,3062,2945,2876,2931,2805,6569,6425,16535,2975,2924,6436,6501,6633,3074) ORDER BY FIELD(iCityID, 2848,2872,3068,2969,2834,3054,16253,2808,16129,3035,3040,2866,16507,16196,2956,2806,2912,2941,3058,3075,2929,2934,2963,2821,2889,2936,2937,2832,2786,3052,16220,3081,3082,16506,2835,2828,2887,2858,2991,16505,2871,2794,2793,2971,2853,2919,3016,513,2974,2939,16232,2957,16242,3034,515,3065,3024,3064,516,16460,2877,2831,16504,2824,2967,6303,2892,512,2784,2955,2891,2839,2897,6579,2938,2788,3056,6321,6471,2766,2792,6312,2905,3041,514,6452,2781,7,2911,2874,2823,6473,6578,6316,2878,2875,3045,2796,3078,6496,2822,2870,2804,2785,6588,2927,6485,2837,2844,6434,3049,2774,16213,2764,3048,6459,6424,2928,3076,2980,2851,2865,2852,16240,2830,2890,6652,3067,6520,2802,2884,6307,2958,6601,3071,2942,16191,6560,6545,16252,6474,2800,3028,2978,6540,3015,6408,6522,6572,2943,2773,2827,2989,3050,2782,2986,16626,2798,6644,2883,2845,6624,16194,2950,2873,6484,16228,2840,2981,2856,3026,3032,3033,6512,3036,3039,2881,2960,3004,6629,6350,2993,21,6499,3023,16654,16197,3020,3018,3037,3005,2908,2976,2913,2917,2770,6649,16533,6548,2916,6420,2817,2910,2987,2768,2921,2847,2932,2914,6549,16214,3047,6448,3038,6421,6650,2772,3011,2994,2904,3063,6487,2888,6573,2982,3070,2882,2869,6564,2861,6402,2833,2815,2895,2807,2947,6395,3007,2843,2968,6449,2935,2893,6463,16574,2920,3009,6368,6503,6430,2862,6615,6547,6359,6361,2769,2776,2940,2795,3019,6526,2962,2810,2886,2813,6656,6345,6609,6386,6405,6406,2922,6511,3053,6498,6622,6510,16224,6626,6613,6641,2819,6475,3080,6597,2775,2850,2825,2801,2842,16534,6348,2966,2948,6313,3003,2816,3010,2951,2855,16532,6341,2771,3055,6336,3030,6323,2998,2894,6394,6497,3025,2859,2896,2864,6311,2885,2970,2952,6542,6438,2990,3027,3022,2988,6460,6494,2992,3061,3066,2964,6603,2953,2944,16116,6349,2961,6383,2809,2902,3012,2789,3060,16246,2818,2803,6481,2946,3077,2799,3044,2854,2765,2849,2995,2778,6554,3051,2829,3002,6537,2812,2777,2767,2915,3062,2945,2876,2931,2805,6569,6425,16535,2975,2924,6436,6501,6633,3074) ASC, p.tmPosted DESC LIMIT 24
software jobs, Job Classifieds, IT Jobs, Sales Jobs, Employers, Freelancers, Work from Home in District Heights
